package com.kangyi.user.mapper;

import com.kangyi.dto.FeeQueryDTO;
import com.kangyi.entity.Fee;
import com.kangyi.vo.FeeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Blank
 * @version 1.0
 */
@Mapper
public interface FeeMapper {

    @Select("select * from fee where nursing_home_id = #{nursingHomeId} and type = #{type}")
    List<FeeVO> inquiryNursingHomeFee(FeeQueryDTO feeQueryDTO);

    @Select("SELECT * FROM fee WHERE nursing_home_id = #{id}")
    List<FeeVO> inquiryNursingHomeFees(Integer id);

    @Select("select * from fee where id = #{id};")
    Fee selectById(Integer id);
}
